﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="RabbitSoftwareDataSet" targetNamespace="http://tempuri.org/RabbitSoftwareDataSet.xsd" xmlns:mstns="http://tempuri.org/RabbitSoftwareDataSet.xsd" xmlns="http://tempuri.org/RabbitSoftwareDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="RabbitSoftwareConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="RabbitSoftwareConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.BACKOFFICE.Properties.Settings.GlobalReference.Default.RabbitSoftwareConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EmployeeInfoTableAdapter" GeneratorDataComponentClassName="EmployeeInfoTableAdapter" Name="EmployeeInfo" UserDataComponentName="EmployeeInfoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RabbitSoftwareConnectionString (Settings)" DbObjectName="RabbitSoftware.dbo.EmployeeInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[EmployeeInfo] WHERE (([EmployeeID] = @Original_EmployeeID) AND ((@IsNull_EmployeeTitle = 1 AND [EmployeeTitle] IS NULL) OR ([EmployeeTitle] = @Original_EmployeeTitle)) AND ([EmployeeFirstName] = @Original_EmployeeFirstName) AND ([EmployeeLastName] = @Original_EmployeeLastName) AND ((@IsNull_EmployeeAddress = 1 AND [EmployeeAddress] IS NULL) OR ([EmployeeAddress] = @Original_EmployeeAddress)) AND ((@IsNull_EmployeeCity = 1 AND [EmployeeCity] IS NULL) OR ([EmployeeCity] = @Original_EmployeeCity)) AND ((@IsNull_EmployeeState = 1 AND [EmployeeState] IS NULL) OR ([EmployeeState] = @Original_EmployeeState)) AND ((@IsNull_EmployeeZip = 1 AND [EmployeeZip] IS NULL) OR ([EmployeeZip] = @Original_EmployeeZip)) AND ((@IsNull_EmployeePhone = 1 AND [EmployeePhone] IS NULL) OR ([EmployeePhone] = @Original_EmployeePhone)) AND ((@IsNull_EmployeeAltPhone = 1 AND [EmployeeAltPhone] IS NULL) OR ([EmployeeAltPhone] = @Original_EmployeeAltPhone)) AND ([EmployeeSocialSecurity] = @Original_EmployeeSocialSecurity) AND ((@IsNull_EmployeePayRate = 1 AND [EmployeePayRate] IS NULL) OR ([EmployeePayRate] = @Original_EmployeePayRate)) AND ((@IsNull_EmployeeHireDate = 1 AND [EmployeeHireDate] IS NULL) OR ([EmployeeHireDate] = @Original_EmployeeHireDate)) AND ((@IsNull_EmployeeTermDate = 1 AND [EmployeeTermDate] IS NULL) OR ([EmployeeTermDate] = @Original_EmployeeTermDate)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EmployeeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeeTitle" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeTitle" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmployeeTitle" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeTitle" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmployeeFirstName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeFirstName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmployeeLastName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeLastName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeeAddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeAddress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmployeeAddress" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeeCity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeCity" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmployeeCity" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeCity" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeeState" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeState" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmployeeState" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeState" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeeZip" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeZip" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmployeeZip" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeZip" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeePhone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeePhone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmployeePhone" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeePhone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeeAltPhone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeAltPhone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmployeeAltPhone" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeAltPhone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmployeeSocialSecurity" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeSocialSecurity" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeePayRate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeePayRate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_EmployeePayRate" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="EmployeePayRate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeeHireDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeHireDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_EmployeeHireDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EmployeeHireDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeeTermDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeTermDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_EmployeeTermDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EmployeeTermDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[EmployeeInfo] ([EmployeeID], [EmployeeTitle], [EmployeeFirstName], [EmployeeLastName], [EmployeeAddress], [EmployeeCity], [EmployeeState], [EmployeeZip], [EmployeePhone], [EmployeeAltPhone], [EmployeeSocialSecurity], [EmployeePayRate], [EmployeeHireDate], [EmployeeTermDate]) VALUES (@EmployeeID, @EmployeeTitle, @EmployeeFirstName, @EmployeeLastName, @EmployeeAddress, @EmployeeCity, @EmployeeState, @EmployeeZip, @EmployeePhone, @EmployeeAltPhone, @EmployeeSocialSecurity, @EmployeePayRate, @EmployeeHireDate, @EmployeeTermDate);
SELECT EmployeeID, EmployeeTitle, EmployeeFirstName, EmployeeLastName, EmployeeAddress, EmployeeCity, EmployeeState, EmployeeZip, EmployeePhone, EmployeeAltPhone, EmployeeSocialSecurity, EmployeePayRate, EmployeeHireDate, EmployeeTermDate FROM EmployeeInfo WHERE (EmployeeID = @EmployeeID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EmployeeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmployeeTitle" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmployeeFirstName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeFirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmployeeLastName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeLastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmployeeAddress" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmployeeCity" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeCity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmployeeState" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeState" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmployeeZip" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeZip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmployeePhone" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeePhone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmployeeAltPhone" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeAltPhone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmployeeSocialSecurity" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeSocialSecurity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@EmployeePayRate" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="EmployeePayRate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@EmployeeHireDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EmployeeHireDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@EmployeeTermDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EmployeeTermDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT EmployeeID, EmployeeTitle, EmployeeFirstName, EmployeeLastName, EmployeeAddress, EmployeeCity, EmployeeState, EmployeeZip, EmployeePhone, EmployeeAltPhone, EmployeeSocialSecurity, EmployeePayRate, EmployeeHireDate, EmployeeTermDate FROM dbo.EmployeeInfo</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[EmployeeInfo] SET [EmployeeID] = @EmployeeID, [EmployeeTitle] = @EmployeeTitle, [EmployeeFirstName] = @EmployeeFirstName, [EmployeeLastName] = @EmployeeLastName, [EmployeeAddress] = @EmployeeAddress, [EmployeeCity] = @EmployeeCity, [EmployeeState] = @EmployeeState, [EmployeeZip] = @EmployeeZip, [EmployeePhone] = @EmployeePhone, [EmployeeAltPhone] = @EmployeeAltPhone, [EmployeeSocialSecurity] = @EmployeeSocialSecurity, [EmployeePayRate] = @EmployeePayRate, [EmployeeHireDate] = @EmployeeHireDate, [EmployeeTermDate] = @EmployeeTermDate WHERE (([EmployeeID] = @Original_EmployeeID) AND ((@IsNull_EmployeeTitle = 1 AND [EmployeeTitle] IS NULL) OR ([EmployeeTitle] = @Original_EmployeeTitle)) AND ([EmployeeFirstName] = @Original_EmployeeFirstName) AND ([EmployeeLastName] = @Original_EmployeeLastName) AND ((@IsNull_EmployeeAddress = 1 AND [EmployeeAddress] IS NULL) OR ([EmployeeAddress] = @Original_EmployeeAddress)) AND ((@IsNull_EmployeeCity = 1 AND [EmployeeCity] IS NULL) OR ([EmployeeCity] = @Original_EmployeeCity)) AND ((@IsNull_EmployeeState = 1 AND [EmployeeState] IS NULL) OR ([EmployeeState] = @Original_EmployeeState)) AND ((@IsNull_EmployeeZip = 1 AND [EmployeeZip] IS NULL) OR ([EmployeeZip] = @Original_EmployeeZip)) AND ((@IsNull_EmployeePhone = 1 AND [EmployeePhone] IS NULL) OR ([EmployeePhone] = @Original_EmployeePhone)) AND ((@IsNull_EmployeeAltPhone = 1 AND [EmployeeAltPhone] IS NULL) OR ([EmployeeAltPhone] = @Original_EmployeeAltPhone)) AND ([EmployeeSocialSecurity] = @Original_EmployeeSocialSecurity) AND ((@IsNull_EmployeePayRate = 1 AND [EmployeePayRate] IS NULL) OR ([EmployeePayRate] = @Original_EmployeePayRate)) AND ((@IsNull_EmployeeHireDate = 1 AND [EmployeeHireDate] IS NULL) OR ([EmployeeHireDate] = @Original_EmployeeHireDate)) AND ((@IsNull_EmployeeTermDate = 1 AND [EmployeeTermDate] IS NULL) OR ([EmployeeTermDate] = @Original_EmployeeTermDate)));
SELECT EmployeeID, EmployeeTitle, EmployeeFirstName, EmployeeLastName, EmployeeAddress, EmployeeCity, EmployeeState, EmployeeZip, EmployeePhone, EmployeeAltPhone, EmployeeSocialSecurity, EmployeePayRate, EmployeeHireDate, EmployeeTermDate FROM EmployeeInfo WHERE (EmployeeID = @EmployeeID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EmployeeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmployeeTitle" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmployeeFirstName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeFirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmployeeLastName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeLastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmployeeAddress" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmployeeCity" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeCity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmployeeState" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeState" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmployeeZip" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeZip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmployeePhone" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeePhone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmployeeAltPhone" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeAltPhone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmployeeSocialSecurity" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeSocialSecurity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@EmployeePayRate" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="EmployeePayRate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@EmployeeHireDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EmployeeHireDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@EmployeeTermDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EmployeeTermDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EmployeeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeeTitle" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeTitle" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmployeeTitle" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeTitle" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmployeeFirstName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeFirstName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmployeeLastName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeLastName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeeAddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeAddress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmployeeAddress" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeeCity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeCity" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmployeeCity" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeCity" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeeState" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeState" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmployeeState" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeState" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeeZip" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeZip" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmployeeZip" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeZip" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeePhone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeePhone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmployeePhone" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeePhone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeeAltPhone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeAltPhone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmployeeAltPhone" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeAltPhone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmployeeSocialSecurity" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeSocialSecurity" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeePayRate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeePayRate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_EmployeePayRate" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="EmployeePayRate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeeHireDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeHireDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_EmployeeHireDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EmployeeHireDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeeTermDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeTermDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_EmployeeTermDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EmployeeTermDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="EmployeeID" DataSetColumn="EmployeeID" />
              <Mapping SourceColumn="EmployeeTitle" DataSetColumn="EmployeeTitle" />
              <Mapping SourceColumn="EmployeeFirstName" DataSetColumn="EmployeeFirstName" />
              <Mapping SourceColumn="EmployeeLastName" DataSetColumn="EmployeeLastName" />
              <Mapping SourceColumn="EmployeeAddress" DataSetColumn="EmployeeAddress" />
              <Mapping SourceColumn="EmployeeCity" DataSetColumn="EmployeeCity" />
              <Mapping SourceColumn="EmployeeState" DataSetColumn="EmployeeState" />
              <Mapping SourceColumn="EmployeeZip" DataSetColumn="EmployeeZip" />
              <Mapping SourceColumn="EmployeePhone" DataSetColumn="EmployeePhone" />
              <Mapping SourceColumn="EmployeeAltPhone" DataSetColumn="EmployeeAltPhone" />
              <Mapping SourceColumn="EmployeeSocialSecurity" DataSetColumn="EmployeeSocialSecurity" />
              <Mapping SourceColumn="EmployeePayRate" DataSetColumn="EmployeePayRate" />
              <Mapping SourceColumn="EmployeeHireDate" DataSetColumn="EmployeeHireDate" />
              <Mapping SourceColumn="EmployeeTermDate" DataSetColumn="EmployeeTermDate" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EmployeeLoginTableAdapter" GeneratorDataComponentClassName="EmployeeLoginTableAdapter" Name="EmployeeLogin" UserDataComponentName="EmployeeLoginTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RabbitSoftwareConnectionString (Settings)" DbObjectName="RabbitSoftware.dbo.EmployeeLogin" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[EmployeeLogin] WHERE (([EmployeeID] = @Original_EmployeeID) AND ([EmployeePassword] = @Original_EmployeePassword) AND ((@IsNull_EmployeeFullName = 1 AND [EmployeeFullName] IS NULL) OR ([EmployeeFullName] = @Original_EmployeeFullName)) AND ((@IsNull_EmployeeTitle = 1 AND [EmployeeTitle] IS NULL) OR ([EmployeeTitle] = @Original_EmployeeTitle)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EmployeeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EmployeePassword" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeePassword" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeeFullName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeFullName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmployeeFullName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeFullName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeeTitle" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeTitle" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmployeeTitle" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeTitle" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[EmployeeLogin] ([EmployeeID], [EmployeePassword], [EmployeeFullName], [EmployeeTitle]) VALUES (@EmployeeID, @EmployeePassword, @EmployeeFullName, @EmployeeTitle);
SELECT EmployeeID, EmployeePassword, EmployeeFullName, EmployeeTitle FROM EmployeeLogin WHERE (EmployeeID = @EmployeeID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EmployeeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EmployeePassword" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeePassword" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmployeeFullName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeFullName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmployeeTitle" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT EmployeeID, EmployeePassword, EmployeeFullName, EmployeeTitle FROM dbo.EmployeeLogin</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[EmployeeLogin] SET [EmployeeID] = @EmployeeID, [EmployeePassword] = @EmployeePassword, [EmployeeFullName] = @EmployeeFullName, [EmployeeTitle] = @EmployeeTitle WHERE (([EmployeeID] = @Original_EmployeeID) AND ([EmployeePassword] = @Original_EmployeePassword) AND ((@IsNull_EmployeeFullName = 1 AND [EmployeeFullName] IS NULL) OR ([EmployeeFullName] = @Original_EmployeeFullName)) AND ((@IsNull_EmployeeTitle = 1 AND [EmployeeTitle] IS NULL) OR ([EmployeeTitle] = @Original_EmployeeTitle)));
SELECT EmployeeID, EmployeePassword, EmployeeFullName, EmployeeTitle FROM EmployeeLogin WHERE (EmployeeID = @EmployeeID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EmployeeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EmployeePassword" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeePassword" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmployeeFullName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeFullName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmployeeTitle" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EmployeeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EmployeePassword" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeePassword" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeeFullName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeFullName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmployeeFullName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeFullName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeeTitle" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeTitle" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmployeeTitle" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmployeeTitle" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="EmployeeID" DataSetColumn="EmployeeID" />
              <Mapping SourceColumn="EmployeePassword" DataSetColumn="EmployeePassword" />
              <Mapping SourceColumn="EmployeeFullName" DataSetColumn="EmployeeFullName" />
              <Mapping SourceColumn="EmployeeTitle" DataSetColumn="EmployeeTitle" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EmployeeTimeSheetTableAdapter" GeneratorDataComponentClassName="EmployeeTimeSheetTableAdapter" Name="EmployeeTimeSheet" UserDataComponentName="EmployeeTimeSheetTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RabbitSoftwareConnectionString (Settings)" DbObjectName="RabbitSoftware.dbo.EmployeeTimeSheet" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[EmployeeTimeSheet] WHERE (([EntryID] = @Original_EntryID) AND ((@IsNull_EmployeeID = 1 AND [EmployeeID] IS NULL) OR ([EmployeeID] = @Original_EmployeeID)) AND ((@IsNull_EntryDate = 1 AND [EntryDate] IS NULL) OR ([EntryDate] = @Original_EntryDate)) AND ((@IsNull_EntryClockIN = 1 AND [EntryClockIN] IS NULL) OR ([EntryClockIN] = @Original_EntryClockIN)) AND ((@IsNull_EntryClockOUT = 1 AND [EntryClockOUT] IS NULL) OR ([EntryClockOUT] = @Original_EntryClockOUT)) AND ((@IsNull_EntryHoursTotal = 1 AND [EntryHoursTotal] IS NULL) OR ([EntryHoursTotal] = @Original_EntryHoursTotal)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_EntryID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="EntryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EmployeeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EntryDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EntryDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_EntryDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EntryDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EntryClockIN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EntryClockIN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EntryClockIN" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EntryClockIN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EntryClockOUT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EntryClockOUT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EntryClockOUT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EntryClockOUT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EntryHoursTotal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EntryHoursTotal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EntryHoursTotal" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EntryHoursTotal" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[EmployeeTimeSheet] ([EntryID], [EmployeeID], [EntryDate], [EntryClockIN], [EntryClockOUT], [EntryHoursTotal]) VALUES (@EntryID, @EmployeeID, @EntryDate, @EntryClockIN, @EntryClockOUT, @EntryHoursTotal);
SELECT EntryID, EmployeeID, EntryDate, EntryClockIN, EntryClockOUT, EntryHoursTotal FROM EmployeeTimeSheet WHERE (EntryID = @EntryID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@EntryID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="EntryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EmployeeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@EntryDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EntryDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EntryClockIN" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EntryClockIN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EntryClockOUT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EntryClockOUT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EntryHoursTotal" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EntryHoursTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT EntryID, EmployeeID, EntryDate, EntryClockIN, EntryClockOUT, EntryHoursTotal FROM dbo.EmployeeTimeSheet</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[EmployeeTimeSheet] SET [EntryID] = @EntryID, [EmployeeID] = @EmployeeID, [EntryDate] = @EntryDate, [EntryClockIN] = @EntryClockIN, [EntryClockOUT] = @EntryClockOUT, [EntryHoursTotal] = @EntryHoursTotal WHERE (([EntryID] = @Original_EntryID) AND ((@IsNull_EmployeeID = 1 AND [EmployeeID] IS NULL) OR ([EmployeeID] = @Original_EmployeeID)) AND ((@IsNull_EntryDate = 1 AND [EntryDate] IS NULL) OR ([EntryDate] = @Original_EntryDate)) AND ((@IsNull_EntryClockIN = 1 AND [EntryClockIN] IS NULL) OR ([EntryClockIN] = @Original_EntryClockIN)) AND ((@IsNull_EntryClockOUT = 1 AND [EntryClockOUT] IS NULL) OR ([EntryClockOUT] = @Original_EntryClockOUT)) AND ((@IsNull_EntryHoursTotal = 1 AND [EntryHoursTotal] IS NULL) OR ([EntryHoursTotal] = @Original_EntryHoursTotal)));
SELECT EntryID, EmployeeID, EntryDate, EntryClockIN, EntryClockOUT, EntryHoursTotal FROM EmployeeTimeSheet WHERE (EntryID = @EntryID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@EntryID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="EntryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EmployeeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@EntryDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EntryDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EntryClockIN" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EntryClockIN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EntryClockOUT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EntryClockOUT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EntryHoursTotal" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EntryHoursTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_EntryID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="EntryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EmployeeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EntryDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EntryDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_EntryDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EntryDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EntryClockIN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EntryClockIN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EntryClockIN" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EntryClockIN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EntryClockOUT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EntryClockOUT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EntryClockOUT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EntryClockOUT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EntryHoursTotal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EntryHoursTotal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EntryHoursTotal" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EntryHoursTotal" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="EntryID" DataSetColumn="EntryID" />
              <Mapping SourceColumn="EmployeeID" DataSetColumn="EmployeeID" />
              <Mapping SourceColumn="EntryDate" DataSetColumn="EntryDate" />
              <Mapping SourceColumn="EntryClockIN" DataSetColumn="EntryClockIN" />
              <Mapping SourceColumn="EntryClockOUT" DataSetColumn="EntryClockOUT" />
              <Mapping SourceColumn="EntryHoursTotal" DataSetColumn="EntryHoursTotal" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MenuCategoryTableAdapter" GeneratorDataComponentClassName="MenuCategoryTableAdapter" Name="MenuCategory" UserDataComponentName="MenuCategoryTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RabbitSoftwareConnectionString (Settings)" DbObjectName="RabbitSoftware.dbo.MenuCategory" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[MenuCategory] ([MenuCategoryID], [MenuCategoryName]) VALUES (@MenuCategoryID, @MenuCategoryName)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MenuCategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MenuCategoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MenuCategoryName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MenuCategoryName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT MenuCategoryID, MenuCategoryName FROM dbo.MenuCategory</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MenuCategoryID" DataSetColumn="MenuCategoryID" />
              <Mapping SourceColumn="MenuCategoryName" DataSetColumn="MenuCategoryName" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MenuItemsTableAdapter" GeneratorDataComponentClassName="MenuItemsTableAdapter" Name="MenuItems" UserDataComponentName="MenuItemsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RabbitSoftwareConnectionString (Settings)" DbObjectName="RabbitSoftware.dbo.MenuItems" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[MenuItems] ([MenuItemID], [MenuItemCategory], [MenuItemName], [MenuItemCost], [MenuItemSalePrice]) VALUES (@MenuItemID, @MenuItemCategory, @MenuItemName, @MenuItemCost, @MenuItemSalePrice)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MenuItemID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MenuItemID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MenuItemCategory" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MenuItemCategory" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MenuItemName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MenuItemName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@MenuItemCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="MenuItemCost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@MenuItemSalePrice" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="MenuItemSalePrice" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT MenuItemID, MenuItemCategory, MenuItemName, MenuItemCost, MenuItemSalePrice FROM dbo.MenuItems</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MenuItemID" DataSetColumn="MenuItemID" />
              <Mapping SourceColumn="MenuItemCategory" DataSetColumn="MenuItemCategory" />
              <Mapping SourceColumn="MenuItemName" DataSetColumn="MenuItemName" />
              <Mapping SourceColumn="MenuItemCost" DataSetColumn="MenuItemCost" />
              <Mapping SourceColumn="MenuItemSalePrice" DataSetColumn="MenuItemSalePrice" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="JobTitlesTableAdapter" GeneratorDataComponentClassName="JobTitlesTableAdapter" Name="JobTitles" UserDataComponentName="JobTitlesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RabbitSoftwareConnectionString (Settings)" DbObjectName="RabbitSoftware.dbo.JobTitles" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[JobTitles] WHERE (([EntryID] = @Original_EntryID) AND ((@IsNull_JobTitles = 1 AND [JobTitles] IS NULL) OR ([JobTitles] = @Original_JobTitles)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EntryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EntryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JobTitles" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JobTitles" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_JobTitles" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="JobTitles" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[JobTitles] ([EntryID], [JobTitles]) VALUES (@EntryID, @JobTitles);
SELECT EntryID, JobTitles FROM JobTitles WHERE (EntryID = @EntryID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EntryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EntryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@JobTitles" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="JobTitles" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT EntryID, JobTitles FROM dbo.JobTitles</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[JobTitles] SET [EntryID] = @EntryID, [JobTitles] = @JobTitles WHERE (([EntryID] = @Original_EntryID) AND ((@IsNull_JobTitles = 1 AND [JobTitles] IS NULL) OR ([JobTitles] = @Original_JobTitles)));
SELECT EntryID, JobTitles FROM JobTitles WHERE (EntryID = @EntryID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EntryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EntryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@JobTitles" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="JobTitles" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EntryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EntryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JobTitles" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JobTitles" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_JobTitles" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="JobTitles" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="EntryID" DataSetColumn="EntryID" />
              <Mapping SourceColumn="JobTitles" DataSetColumn="JobTitles" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ModificationListTableAdapter" GeneratorDataComponentClassName="ModificationListTableAdapter" Name="ModificationList" UserDataComponentName="ModificationListTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RabbitSoftwareConnectionString (Settings)" DbObjectName="RabbitSoftware.dbo.ModificationList" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ModificationList] WHERE (([EntryID] = @Original_EntryID) AND ((@IsNull_MenuItem = 1 AND [MenuItem] IS NULL) OR ([MenuItem] = @Original_MenuItem)) AND ((@IsNull_ModificationType = 1 AND [ModificationType] IS NULL) OR ([ModificationType] = @Original_ModificationType)) AND ((@IsNull_ModificationDescription = 1 AND [ModificationDescription] IS NULL) OR ([ModificationDescription] = @Original_ModificationDescription)) AND ((@IsNull_ModificationPrice = 1 AND [ModificationPrice] IS NULL) OR ([ModificationPrice] = @Original_ModificationPrice)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EntryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EntryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MenuItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MenuItem" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_MenuItem" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MenuItem" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ModificationType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModificationType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ModificationType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ModificationType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ModificationDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModificationDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ModificationDescription" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ModificationDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ModificationPrice" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModificationPrice" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_ModificationPrice" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ModificationPrice" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ModificationList] ([EntryID], [MenuItem], [ModificationType], [ModificationDescription], [ModificationPrice]) VALUES (@EntryID, @MenuItem, @ModificationType, @ModificationDescription, @ModificationPrice);
SELECT EntryID, MenuItem, ModificationType, ModificationDescription, ModificationPrice FROM ModificationList WHERE (EntryID = @EntryID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EntryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EntryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MenuItem" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MenuItem" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ModificationType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ModificationType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ModificationDescription" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ModificationDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ModificationPrice" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ModificationPrice" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT EntryID, MenuItem, ModificationType, ModificationDescription, ModificationPrice FROM dbo.ModificationList</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ModificationList] SET [EntryID] = @EntryID, [MenuItem] = @MenuItem, [ModificationType] = @ModificationType, [ModificationDescription] = @ModificationDescription, [ModificationPrice] = @ModificationPrice WHERE (([EntryID] = @Original_EntryID) AND ((@IsNull_MenuItem = 1 AND [MenuItem] IS NULL) OR ([MenuItem] = @Original_MenuItem)) AND ((@IsNull_ModificationType = 1 AND [ModificationType] IS NULL) OR ([ModificationType] = @Original_ModificationType)) AND ((@IsNull_ModificationDescription = 1 AND [ModificationDescription] IS NULL) OR ([ModificationDescription] = @Original_ModificationDescription)) AND ((@IsNull_ModificationPrice = 1 AND [ModificationPrice] IS NULL) OR ([ModificationPrice] = @Original_ModificationPrice)));
SELECT EntryID, MenuItem, ModificationType, ModificationDescription, ModificationPrice FROM ModificationList WHERE (EntryID = @EntryID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EntryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EntryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MenuItem" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MenuItem" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ModificationType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ModificationType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ModificationDescription" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ModificationDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ModificationPrice" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ModificationPrice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EntryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EntryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MenuItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MenuItem" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_MenuItem" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MenuItem" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ModificationType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModificationType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ModificationType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ModificationType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ModificationDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModificationDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ModificationDescription" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ModificationDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ModificationPrice" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModificationPrice" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_ModificationPrice" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ModificationPrice" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="EntryID" DataSetColumn="EntryID" />
              <Mapping SourceColumn="MenuItem" DataSetColumn="MenuItem" />
              <Mapping SourceColumn="ModificationType" DataSetColumn="ModificationType" />
              <Mapping SourceColumn="ModificationDescription" DataSetColumn="ModificationDescription" />
              <Mapping SourceColumn="ModificationPrice" DataSetColumn="ModificationPrice" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PaymentTypesTableAdapter" GeneratorDataComponentClassName="PaymentTypesTableAdapter" Name="PaymentTypes" UserDataComponentName="PaymentTypesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RabbitSoftwareConnectionString (Settings)" DbObjectName="RabbitSoftware.dbo.PaymentTypes" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[PaymentTypes] WHERE (([EntryID] = @Original_EntryID) AND ((@IsNull_PaymentType = 1 AND [PaymentType] IS NULL) OR ([PaymentType] = @Original_PaymentType)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EntryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EntryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PaymentType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PaymentType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_PaymentType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PaymentType" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[PaymentTypes] ([EntryID], [PaymentType]) VALUES (@EntryID, @PaymentType);
SELECT EntryID, PaymentType FROM PaymentTypes WHERE (EntryID = @EntryID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EntryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EntryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@PaymentType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PaymentType" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT EntryID, PaymentType FROM dbo.PaymentTypes</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[PaymentTypes] SET [EntryID] = @EntryID, [PaymentType] = @PaymentType WHERE (([EntryID] = @Original_EntryID) AND ((@IsNull_PaymentType = 1 AND [PaymentType] IS NULL) OR ([PaymentType] = @Original_PaymentType)));
SELECT EntryID, PaymentType FROM PaymentTypes WHERE (EntryID = @EntryID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EntryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EntryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@PaymentType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PaymentType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EntryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EntryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PaymentType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PaymentType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_PaymentType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PaymentType" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="EntryID" DataSetColumn="EntryID" />
              <Mapping SourceColumn="PaymentType" DataSetColumn="PaymentType" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ReceiptTableAdapter" GeneratorDataComponentClassName="ReceiptTableAdapter" Name="Receipt" UserDataComponentName="ReceiptTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RabbitSoftwareConnectionString (Settings)" DbObjectName="RabbitSoftware.dbo.Receipt" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Receipt] WHERE (([ReceiptNo] = @Original_ReceiptNo) AND ((@IsNull_ReceiptDate = 1 AND [ReceiptDate] IS NULL) OR ([ReceiptDate] = @Original_ReceiptDate)) AND ((@IsNull_ReceiptTableName = 1 AND [ReceiptTableName] IS NULL) OR ([ReceiptTableName] = @Original_ReceiptTableName)) AND ((@IsNull_ReceiptServerName = 1 AND [ReceiptServerName] IS NULL) OR ([ReceiptServerName] = @Original_ReceiptServerName)) AND ((@IsNull_ReceiptSubTotal = 1 AND [ReceiptSubTotal] IS NULL) OR ([ReceiptSubTotal] = @Original_ReceiptSubTotal)) AND ((@IsNull_ReceiptTaxTotal = 1 AND [ReceiptTaxTotal] IS NULL) OR ([ReceiptTaxTotal] = @Original_ReceiptTaxTotal)) AND ((@IsNull_ReceiptAutoGrat = 1 AND [ReceiptAutoGrat] IS NULL) OR ([ReceiptAutoGrat] = @Original_ReceiptAutoGrat)) AND ((@IsNull_ReceiptGrat = 1 AND [ReceiptGrat] IS NULL) OR ([ReceiptGrat] = @Original_ReceiptGrat)) AND ((@IsNull_ReceiptDiscountTotal = 1 AND [ReceiptDiscountTotal] IS NULL) OR ([ReceiptDiscountTotal] = @Original_ReceiptDiscountTotal)) AND ((@IsNull_ReceiptGrandTotal = 1 AND [ReceiptGrandTotal] IS NULL) OR ([ReceiptGrandTotal] = @Original_ReceiptGrandTotal)) AND ((@IsNull_ReceiptPaymentType = 1 AND [ReceiptPaymentType] IS NULL) OR ([ReceiptPaymentType] = @Original_ReceiptPaymentType)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ReceiptNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReceiptNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ReceiptDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReceiptDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_ReceiptDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ReceiptDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ReceiptTableName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReceiptTableName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ReceiptTableName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ReceiptTableName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ReceiptServerName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReceiptServerName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ReceiptServerName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ReceiptServerName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ReceiptSubTotal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReceiptSubTotal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_ReceiptSubTotal" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ReceiptSubTotal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ReceiptTaxTotal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReceiptTaxTotal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_ReceiptTaxTotal" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ReceiptTaxTotal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ReceiptAutoGrat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReceiptAutoGrat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_ReceiptAutoGrat" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ReceiptAutoGrat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ReceiptGrat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReceiptGrat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_ReceiptGrat" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ReceiptGrat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ReceiptDiscountTotal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReceiptDiscountTotal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_ReceiptDiscountTotal" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ReceiptDiscountTotal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ReceiptGrandTotal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReceiptGrandTotal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_ReceiptGrandTotal" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ReceiptGrandTotal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ReceiptPaymentType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReceiptPaymentType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ReceiptPaymentType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ReceiptPaymentType" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Receipt] ([ReceiptNo], [ReceiptDate], [ReceiptTableName], [ReceiptServerName], [ReceiptSubTotal], [ReceiptTaxTotal], [ReceiptAutoGrat], [ReceiptGrat], [ReceiptDiscountTotal], [ReceiptGrandTotal], [ReceiptPaymentType]) VALUES (@ReceiptNo, @ReceiptDate, @ReceiptTableName, @ReceiptServerName, @ReceiptSubTotal, @ReceiptTaxTotal, @ReceiptAutoGrat, @ReceiptGrat, @ReceiptDiscountTotal, @ReceiptGrandTotal, @ReceiptPaymentType);
SELECT ReceiptNo, ReceiptDate, ReceiptTableName, ReceiptServerName, ReceiptSubTotal, ReceiptTaxTotal, ReceiptAutoGrat, ReceiptGrat, ReceiptDiscountTotal, ReceiptGrandTotal, ReceiptPaymentType FROM Receipt WHERE (ReceiptNo = @ReceiptNo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ReceiptNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReceiptNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@ReceiptDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ReceiptDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ReceiptTableName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ReceiptTableName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ReceiptServerName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ReceiptServerName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ReceiptSubTotal" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ReceiptSubTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ReceiptTaxTotal" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ReceiptTaxTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ReceiptAutoGrat" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ReceiptAutoGrat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ReceiptGrat" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ReceiptGrat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ReceiptDiscountTotal" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ReceiptDiscountTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ReceiptGrandTotal" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ReceiptGrandTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ReceiptPaymentType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ReceiptPaymentType" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ReceiptNo, ReceiptDate, ReceiptTableName, ReceiptServerName, ReceiptSubTotal, ReceiptTaxTotal, ReceiptAutoGrat, ReceiptGrat, ReceiptDiscountTotal, ReceiptGrandTotal, ReceiptPaymentType FROM dbo.Receipt</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Receipt] SET [ReceiptNo] = @ReceiptNo, [ReceiptDate] = @ReceiptDate, [ReceiptTableName] = @ReceiptTableName, [ReceiptServerName] = @ReceiptServerName, [ReceiptSubTotal] = @ReceiptSubTotal, [ReceiptTaxTotal] = @ReceiptTaxTotal, [ReceiptAutoGrat] = @ReceiptAutoGrat, [ReceiptGrat] = @ReceiptGrat, [ReceiptDiscountTotal] = @ReceiptDiscountTotal, [ReceiptGrandTotal] = @ReceiptGrandTotal, [ReceiptPaymentType] = @ReceiptPaymentType WHERE (([ReceiptNo] = @Original_ReceiptNo) AND ((@IsNull_ReceiptDate = 1 AND [ReceiptDate] IS NULL) OR ([ReceiptDate] = @Original_ReceiptDate)) AND ((@IsNull_ReceiptTableName = 1 AND [ReceiptTableName] IS NULL) OR ([ReceiptTableName] = @Original_ReceiptTableName)) AND ((@IsNull_ReceiptServerName = 1 AND [ReceiptServerName] IS NULL) OR ([ReceiptServerName] = @Original_ReceiptServerName)) AND ((@IsNull_ReceiptSubTotal = 1 AND [ReceiptSubTotal] IS NULL) OR ([ReceiptSubTotal] = @Original_ReceiptSubTotal)) AND ((@IsNull_ReceiptTaxTotal = 1 AND [ReceiptTaxTotal] IS NULL) OR ([ReceiptTaxTotal] = @Original_ReceiptTaxTotal)) AND ((@IsNull_ReceiptAutoGrat = 1 AND [ReceiptAutoGrat] IS NULL) OR ([ReceiptAutoGrat] = @Original_ReceiptAutoGrat)) AND ((@IsNull_ReceiptGrat = 1 AND [ReceiptGrat] IS NULL) OR ([ReceiptGrat] = @Original_ReceiptGrat)) AND ((@IsNull_ReceiptDiscountTotal = 1 AND [ReceiptDiscountTotal] IS NULL) OR ([ReceiptDiscountTotal] = @Original_ReceiptDiscountTotal)) AND ((@IsNull_ReceiptGrandTotal = 1 AND [ReceiptGrandTotal] IS NULL) OR ([ReceiptGrandTotal] = @Original_ReceiptGrandTotal)) AND ((@IsNull_ReceiptPaymentType = 1 AND [ReceiptPaymentType] IS NULL) OR ([ReceiptPaymentType] = @Original_ReceiptPaymentType)));
SELECT ReceiptNo, ReceiptDate, ReceiptTableName, ReceiptServerName, ReceiptSubTotal, ReceiptTaxTotal, ReceiptAutoGrat, ReceiptGrat, ReceiptDiscountTotal, ReceiptGrandTotal, ReceiptPaymentType FROM Receipt WHERE (ReceiptNo = @ReceiptNo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ReceiptNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReceiptNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@ReceiptDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ReceiptDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ReceiptTableName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ReceiptTableName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ReceiptServerName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ReceiptServerName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ReceiptSubTotal" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ReceiptSubTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ReceiptTaxTotal" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ReceiptTaxTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ReceiptAutoGrat" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ReceiptAutoGrat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ReceiptGrat" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ReceiptGrat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ReceiptDiscountTotal" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ReceiptDiscountTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ReceiptGrandTotal" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ReceiptGrandTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ReceiptPaymentType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ReceiptPaymentType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ReceiptNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReceiptNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ReceiptDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReceiptDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_ReceiptDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ReceiptDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ReceiptTableName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReceiptTableName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ReceiptTableName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ReceiptTableName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ReceiptServerName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReceiptServerName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ReceiptServerName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ReceiptServerName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ReceiptSubTotal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReceiptSubTotal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_ReceiptSubTotal" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ReceiptSubTotal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ReceiptTaxTotal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReceiptTaxTotal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_ReceiptTaxTotal" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ReceiptTaxTotal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ReceiptAutoGrat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReceiptAutoGrat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_ReceiptAutoGrat" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ReceiptAutoGrat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ReceiptGrat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReceiptGrat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_ReceiptGrat" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ReceiptGrat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ReceiptDiscountTotal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReceiptDiscountTotal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_ReceiptDiscountTotal" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ReceiptDiscountTotal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ReceiptGrandTotal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReceiptGrandTotal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_ReceiptGrandTotal" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ReceiptGrandTotal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ReceiptPaymentType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReceiptPaymentType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ReceiptPaymentType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ReceiptPaymentType" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ReceiptNo" DataSetColumn="ReceiptNo" />
              <Mapping SourceColumn="ReceiptDate" DataSetColumn="ReceiptDate" />
              <Mapping SourceColumn="ReceiptTableName" DataSetColumn="ReceiptTableName" />
              <Mapping SourceColumn="ReceiptServerName" DataSetColumn="ReceiptServerName" />
              <Mapping SourceColumn="ReceiptSubTotal" DataSetColumn="ReceiptSubTotal" />
              <Mapping SourceColumn="ReceiptTaxTotal" DataSetColumn="ReceiptTaxTotal" />
              <Mapping SourceColumn="ReceiptAutoGrat" DataSetColumn="ReceiptAutoGrat" />
              <Mapping SourceColumn="ReceiptGrat" DataSetColumn="ReceiptGrat" />
              <Mapping SourceColumn="ReceiptDiscountTotal" DataSetColumn="ReceiptDiscountTotal" />
              <Mapping SourceColumn="ReceiptGrandTotal" DataSetColumn="ReceiptGrandTotal" />
              <Mapping SourceColumn="ReceiptPaymentType" DataSetColumn="ReceiptPaymentType" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ReceiptDataTableAdapter" GeneratorDataComponentClassName="ReceiptDataTableAdapter" Name="ReceiptData" UserDataComponentName="ReceiptDataTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RabbitSoftwareConnectionString (Settings)" DbObjectName="RabbitSoftware.dbo.ReceiptData" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ReceiptData] ([ReceiptNo], [ReceiptQTY], [ReceiptDescription], [ReceiptItemTotal]) VALUES (@ReceiptNo, @ReceiptQTY, @ReceiptDescription, @ReceiptItemTotal)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ReceiptNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReceiptNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ReceiptQTY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReceiptQTY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ReceiptDescription" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ReceiptDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ReceiptItemTotal" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ReceiptItemTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ReceiptNo, ReceiptQTY, ReceiptDescription, ReceiptItemTotal FROM dbo.ReceiptData</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ReceiptNo" DataSetColumn="ReceiptNo" />
              <Mapping SourceColumn="ReceiptQTY" DataSetColumn="ReceiptQTY" />
              <Mapping SourceColumn="ReceiptDescription" DataSetColumn="ReceiptDescription" />
              <Mapping SourceColumn="ReceiptItemTotal" DataSetColumn="ReceiptItemTotal" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="RabbitSoftwareDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="RabbitSoftwareDataSet" msprop:Generator_UserDSName="RabbitSoftwareDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="EmployeeInfo" msprop:Generator_TableClassName="EmployeeInfoDataTable" msprop:Generator_TableVarName="tableEmployeeInfo" msprop:Generator_RowChangedName="EmployeeInfoRowChanged" msprop:Generator_TablePropName="EmployeeInfo" msprop:Generator_RowDeletingName="EmployeeInfoRowDeleting" msprop:Generator_RowChangingName="EmployeeInfoRowChanging" msprop:Generator_RowEvHandlerName="EmployeeInfoRowChangeEventHandler" msprop:Generator_RowDeletedName="EmployeeInfoRowDeleted" msprop:Generator_RowClassName="EmployeeInfoRow" msprop:Generator_UserTableName="EmployeeInfo" msprop:Generator_RowEvArgName="EmployeeInfoRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EmployeeID" msprop:Generator_ColumnVarNameInTable="columnEmployeeID" msprop:Generator_ColumnPropNameInRow="EmployeeID" msprop:Generator_ColumnPropNameInTable="EmployeeIDColumn" msprop:Generator_UserColumnName="EmployeeID" type="xs:int" />
              <xs:element name="EmployeeTitle" msprop:Generator_ColumnVarNameInTable="columnEmployeeTitle" msprop:Generator_ColumnPropNameInRow="EmployeeTitle" msprop:Generator_ColumnPropNameInTable="EmployeeTitleColumn" msprop:Generator_UserColumnName="EmployeeTitle" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EmployeeFirstName" msprop:Generator_ColumnVarNameInTable="columnEmployeeFirstName" msprop:Generator_ColumnPropNameInRow="EmployeeFirstName" msprop:Generator_ColumnPropNameInTable="EmployeeFirstNameColumn" msprop:Generator_UserColumnName="EmployeeFirstName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EmployeeLastName" msprop:Generator_ColumnVarNameInTable="columnEmployeeLastName" msprop:Generator_ColumnPropNameInRow="EmployeeLastName" msprop:Generator_ColumnPropNameInTable="EmployeeLastNameColumn" msprop:Generator_UserColumnName="EmployeeLastName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EmployeeAddress" msprop:Generator_ColumnVarNameInTable="columnEmployeeAddress" msprop:Generator_ColumnPropNameInRow="EmployeeAddress" msprop:Generator_ColumnPropNameInTable="EmployeeAddressColumn" msprop:Generator_UserColumnName="EmployeeAddress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EmployeeCity" msprop:Generator_ColumnVarNameInTable="columnEmployeeCity" msprop:Generator_ColumnPropNameInRow="EmployeeCity" msprop:Generator_ColumnPropNameInTable="EmployeeCityColumn" msprop:Generator_UserColumnName="EmployeeCity" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EmployeeState" msprop:Generator_ColumnVarNameInTable="columnEmployeeState" msprop:Generator_ColumnPropNameInRow="EmployeeState" msprop:Generator_ColumnPropNameInTable="EmployeeStateColumn" msprop:Generator_UserColumnName="EmployeeState" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EmployeeZip" msprop:Generator_ColumnVarNameInTable="columnEmployeeZip" msprop:Generator_ColumnPropNameInRow="EmployeeZip" msprop:Generator_ColumnPropNameInTable="EmployeeZipColumn" msprop:Generator_UserColumnName="EmployeeZip" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EmployeePhone" msprop:Generator_ColumnVarNameInTable="columnEmployeePhone" msprop:Generator_ColumnPropNameInRow="EmployeePhone" msprop:Generator_ColumnPropNameInTable="EmployeePhoneColumn" msprop:Generator_UserColumnName="EmployeePhone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EmployeeAltPhone" msprop:Generator_ColumnVarNameInTable="columnEmployeeAltPhone" msprop:Generator_ColumnPropNameInRow="EmployeeAltPhone" msprop:Generator_ColumnPropNameInTable="EmployeeAltPhoneColumn" msprop:Generator_UserColumnName="EmployeeAltPhone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EmployeeSocialSecurity" msprop:Generator_ColumnVarNameInTable="columnEmployeeSocialSecurity" msprop:Generator_ColumnPropNameInRow="EmployeeSocialSecurity" msprop:Generator_ColumnPropNameInTable="EmployeeSocialSecurityColumn" msprop:Generator_UserColumnName="EmployeeSocialSecurity">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EmployeePayRate" msprop:Generator_ColumnVarNameInTable="columnEmployeePayRate" msprop:Generator_ColumnPropNameInRow="EmployeePayRate" msprop:Generator_ColumnPropNameInTable="EmployeePayRateColumn" msprop:Generator_UserColumnName="EmployeePayRate" type="xs:decimal" minOccurs="0" />
              <xs:element name="EmployeeHireDate" msprop:Generator_ColumnVarNameInTable="columnEmployeeHireDate" msprop:Generator_ColumnPropNameInRow="EmployeeHireDate" msprop:Generator_ColumnPropNameInTable="EmployeeHireDateColumn" msprop:Generator_UserColumnName="EmployeeHireDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="EmployeeTermDate" msprop:Generator_ColumnVarNameInTable="columnEmployeeTermDate" msprop:Generator_ColumnPropNameInRow="EmployeeTermDate" msprop:Generator_ColumnPropNameInTable="EmployeeTermDateColumn" msprop:Generator_UserColumnName="EmployeeTermDate" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="EmployeeLogin" msprop:Generator_TableClassName="EmployeeLoginDataTable" msprop:Generator_TableVarName="tableEmployeeLogin" msprop:Generator_RowChangedName="EmployeeLoginRowChanged" msprop:Generator_TablePropName="EmployeeLogin" msprop:Generator_RowDeletingName="EmployeeLoginRowDeleting" msprop:Generator_RowChangingName="EmployeeLoginRowChanging" msprop:Generator_RowEvHandlerName="EmployeeLoginRowChangeEventHandler" msprop:Generator_RowDeletedName="EmployeeLoginRowDeleted" msprop:Generator_RowClassName="EmployeeLoginRow" msprop:Generator_UserTableName="EmployeeLogin" msprop:Generator_RowEvArgName="EmployeeLoginRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EmployeeID" msprop:Generator_ColumnVarNameInTable="columnEmployeeID" msprop:Generator_ColumnPropNameInRow="EmployeeID" msprop:Generator_ColumnPropNameInTable="EmployeeIDColumn" msprop:Generator_UserColumnName="EmployeeID" type="xs:int" />
              <xs:element name="EmployeePassword" msprop:Generator_ColumnVarNameInTable="columnEmployeePassword" msprop:Generator_ColumnPropNameInRow="EmployeePassword" msprop:Generator_ColumnPropNameInTable="EmployeePasswordColumn" msprop:Generator_UserColumnName="EmployeePassword" type="xs:int" />
              <xs:element name="EmployeeFullName" msprop:Generator_ColumnVarNameInTable="columnEmployeeFullName" msprop:Generator_ColumnPropNameInRow="EmployeeFullName" msprop:Generator_ColumnPropNameInTable="EmployeeFullNameColumn" msprop:Generator_UserColumnName="EmployeeFullName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EmployeeTitle" msprop:Generator_ColumnVarNameInTable="columnEmployeeTitle" msprop:Generator_ColumnPropNameInRow="EmployeeTitle" msprop:Generator_ColumnPropNameInTable="EmployeeTitleColumn" msprop:Generator_UserColumnName="EmployeeTitle" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="EmployeeTimeSheet" msprop:Generator_TableClassName="EmployeeTimeSheetDataTable" msprop:Generator_TableVarName="tableEmployeeTimeSheet" msprop:Generator_RowChangedName="EmployeeTimeSheetRowChanged" msprop:Generator_TablePropName="EmployeeTimeSheet" msprop:Generator_RowDeletingName="EmployeeTimeSheetRowDeleting" msprop:Generator_RowChangingName="EmployeeTimeSheetRowChanging" msprop:Generator_RowEvHandlerName="EmployeeTimeSheetRowChangeEventHandler" msprop:Generator_RowDeletedName="EmployeeTimeSheetRowDeleted" msprop:Generator_RowClassName="EmployeeTimeSheetRow" msprop:Generator_UserTableName="EmployeeTimeSheet" msprop:Generator_RowEvArgName="EmployeeTimeSheetRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EntryID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnEntryID" msprop:Generator_ColumnPropNameInRow="EntryID" msprop:Generator_ColumnPropNameInTable="EntryIDColumn" msprop:Generator_UserColumnName="EntryID" type="xs:string" />
              <xs:element name="EmployeeID" msprop:Generator_ColumnVarNameInTable="columnEmployeeID" msprop:Generator_ColumnPropNameInRow="EmployeeID" msprop:Generator_ColumnPropNameInTable="EmployeeIDColumn" msprop:Generator_UserColumnName="EmployeeID" type="xs:int" minOccurs="0" />
              <xs:element name="EntryDate" msprop:Generator_ColumnVarNameInTable="columnEntryDate" msprop:Generator_ColumnPropNameInRow="EntryDate" msprop:Generator_ColumnPropNameInTable="EntryDateColumn" msprop:Generator_UserColumnName="EntryDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="EntryClockIN" msprop:Generator_ColumnVarNameInTable="columnEntryClockIN" msprop:Generator_ColumnPropNameInRow="EntryClockIN" msprop:Generator_ColumnPropNameInTable="EntryClockINColumn" msprop:Generator_UserColumnName="EntryClockIN" type="xs:dateTime" minOccurs="0" />
              <xs:element name="EntryClockOUT" msprop:Generator_ColumnVarNameInTable="columnEntryClockOUT" msprop:Generator_ColumnPropNameInRow="EntryClockOUT" msprop:Generator_ColumnPropNameInTable="EntryClockOUTColumn" msprop:Generator_UserColumnName="EntryClockOUT" type="xs:dateTime" minOccurs="0" />
              <xs:element name="EntryHoursTotal" msprop:Generator_ColumnVarNameInTable="columnEntryHoursTotal" msprop:Generator_ColumnPropNameInRow="EntryHoursTotal" msprop:Generator_ColumnPropNameInTable="EntryHoursTotalColumn" msprop:Generator_UserColumnName="EntryHoursTotal" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MenuCategory" msprop:Generator_TableClassName="MenuCategoryDataTable" msprop:Generator_TableVarName="tableMenuCategory" msprop:Generator_RowChangedName="MenuCategoryRowChanged" msprop:Generator_TablePropName="MenuCategory" msprop:Generator_RowDeletingName="MenuCategoryRowDeleting" msprop:Generator_RowChangingName="MenuCategoryRowChanging" msprop:Generator_RowEvHandlerName="MenuCategoryRowChangeEventHandler" msprop:Generator_RowDeletedName="MenuCategoryRowDeleted" msprop:Generator_RowClassName="MenuCategoryRow" msprop:Generator_UserTableName="MenuCategory" msprop:Generator_RowEvArgName="MenuCategoryRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MenuCategoryID" msprop:Generator_ColumnVarNameInTable="columnMenuCategoryID" msprop:Generator_ColumnPropNameInRow="MenuCategoryID" msprop:Generator_ColumnPropNameInTable="MenuCategoryIDColumn" msprop:Generator_UserColumnName="MenuCategoryID" type="xs:int" minOccurs="0" />
              <xs:element name="MenuCategoryName" msprop:Generator_ColumnVarNameInTable="columnMenuCategoryName" msprop:Generator_ColumnPropNameInRow="MenuCategoryName" msprop:Generator_ColumnPropNameInTable="MenuCategoryNameColumn" msprop:Generator_UserColumnName="MenuCategoryName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MenuItems" msprop:Generator_TableClassName="MenuItemsDataTable" msprop:Generator_TableVarName="tableMenuItems" msprop:Generator_RowChangedName="MenuItemsRowChanged" msprop:Generator_TablePropName="MenuItems" msprop:Generator_RowDeletingName="MenuItemsRowDeleting" msprop:Generator_RowChangingName="MenuItemsRowChanging" msprop:Generator_RowEvHandlerName="MenuItemsRowChangeEventHandler" msprop:Generator_RowDeletedName="MenuItemsRowDeleted" msprop:Generator_RowClassName="MenuItemsRow" msprop:Generator_UserTableName="MenuItems" msprop:Generator_RowEvArgName="MenuItemsRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MenuItemID" msprop:Generator_ColumnVarNameInTable="columnMenuItemID" msprop:Generator_ColumnPropNameInRow="MenuItemID" msprop:Generator_ColumnPropNameInTable="MenuItemIDColumn" msprop:Generator_UserColumnName="MenuItemID" type="xs:int" />
              <xs:element name="MenuItemCategory" msprop:Generator_ColumnVarNameInTable="columnMenuItemCategory" msprop:Generator_ColumnPropNameInRow="MenuItemCategory" msprop:Generator_ColumnPropNameInTable="MenuItemCategoryColumn" msprop:Generator_UserColumnName="MenuItemCategory" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MenuItemName" msprop:Generator_ColumnVarNameInTable="columnMenuItemName" msprop:Generator_ColumnPropNameInRow="MenuItemName" msprop:Generator_ColumnPropNameInTable="MenuItemNameColumn" msprop:Generator_UserColumnName="MenuItemName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MenuItemCost" msprop:Generator_ColumnVarNameInTable="columnMenuItemCost" msprop:Generator_ColumnPropNameInRow="MenuItemCost" msprop:Generator_ColumnPropNameInTable="MenuItemCostColumn" msprop:Generator_UserColumnName="MenuItemCost" type="xs:decimal" minOccurs="0" />
              <xs:element name="MenuItemSalePrice" msprop:Generator_ColumnVarNameInTable="columnMenuItemSalePrice" msprop:Generator_ColumnPropNameInRow="MenuItemSalePrice" msprop:Generator_ColumnPropNameInTable="MenuItemSalePriceColumn" msprop:Generator_UserColumnName="MenuItemSalePrice" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="JobTitles" msprop:Generator_TableClassName="JobTitlesDataTable" msprop:Generator_TableVarName="tableJobTitles" msprop:Generator_TablePropName="JobTitles" msprop:Generator_RowDeletingName="JobTitlesRowDeleting" msprop:Generator_RowChangingName="JobTitlesRowChanging" msprop:Generator_RowEvHandlerName="JobTitlesRowChangeEventHandler" msprop:Generator_RowDeletedName="JobTitlesRowDeleted" msprop:Generator_UserTableName="JobTitles" msprop:Generator_RowChangedName="JobTitlesRowChanged" msprop:Generator_RowEvArgName="JobTitlesRowChangeEvent" msprop:Generator_RowClassName="JobTitlesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EntryID" msprop:Generator_ColumnVarNameInTable="columnEntryID" msprop:Generator_ColumnPropNameInRow="EntryID" msprop:Generator_ColumnPropNameInTable="EntryIDColumn" msprop:Generator_UserColumnName="EntryID" type="xs:int" />
              <xs:element name="JobTitles" msprop:Generator_ColumnVarNameInTable="columnJobTitles" msprop:Generator_ColumnPropNameInRow="JobTitles" msprop:Generator_ColumnPropNameInTable="JobTitlesColumn" msprop:Generator_UserColumnName="JobTitles" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ModificationList" msprop:Generator_TableClassName="ModificationListDataTable" msprop:Generator_TableVarName="tableModificationList" msprop:Generator_TablePropName="ModificationList" msprop:Generator_RowDeletingName="ModificationListRowDeleting" msprop:Generator_RowChangingName="ModificationListRowChanging" msprop:Generator_RowEvHandlerName="ModificationListRowChangeEventHandler" msprop:Generator_RowDeletedName="ModificationListRowDeleted" msprop:Generator_UserTableName="ModificationList" msprop:Generator_RowChangedName="ModificationListRowChanged" msprop:Generator_RowEvArgName="ModificationListRowChangeEvent" msprop:Generator_RowClassName="ModificationListRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EntryID" msprop:Generator_ColumnVarNameInTable="columnEntryID" msprop:Generator_ColumnPropNameInRow="EntryID" msprop:Generator_ColumnPropNameInTable="EntryIDColumn" msprop:Generator_UserColumnName="EntryID" type="xs:int" />
              <xs:element name="MenuItem" msprop:Generator_ColumnVarNameInTable="columnMenuItem" msprop:Generator_ColumnPropNameInRow="MenuItem" msprop:Generator_ColumnPropNameInTable="MenuItemColumn" msprop:Generator_UserColumnName="MenuItem" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ModificationType" msprop:Generator_ColumnVarNameInTable="columnModificationType" msprop:Generator_ColumnPropNameInRow="ModificationType" msprop:Generator_ColumnPropNameInTable="ModificationTypeColumn" msprop:Generator_UserColumnName="ModificationType" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ModificationDescription" msprop:Generator_ColumnVarNameInTable="columnModificationDescription" msprop:Generator_ColumnPropNameInRow="ModificationDescription" msprop:Generator_ColumnPropNameInTable="ModificationDescriptionColumn" msprop:Generator_UserColumnName="ModificationDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ModificationPrice" msprop:Generator_ColumnVarNameInTable="columnModificationPrice" msprop:Generator_ColumnPropNameInRow="ModificationPrice" msprop:Generator_ColumnPropNameInTable="ModificationPriceColumn" msprop:Generator_UserColumnName="ModificationPrice" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PaymentTypes" msprop:Generator_TableClassName="PaymentTypesDataTable" msprop:Generator_TableVarName="tablePaymentTypes" msprop:Generator_TablePropName="PaymentTypes" msprop:Generator_RowDeletingName="PaymentTypesRowDeleting" msprop:Generator_RowChangingName="PaymentTypesRowChanging" msprop:Generator_RowEvHandlerName="PaymentTypesRowChangeEventHandler" msprop:Generator_RowDeletedName="PaymentTypesRowDeleted" msprop:Generator_UserTableName="PaymentTypes" msprop:Generator_RowChangedName="PaymentTypesRowChanged" msprop:Generator_RowEvArgName="PaymentTypesRowChangeEvent" msprop:Generator_RowClassName="PaymentTypesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EntryID" msprop:Generator_ColumnVarNameInTable="columnEntryID" msprop:Generator_ColumnPropNameInRow="EntryID" msprop:Generator_ColumnPropNameInTable="EntryIDColumn" msprop:Generator_UserColumnName="EntryID" type="xs:int" />
              <xs:element name="PaymentType" msprop:Generator_ColumnVarNameInTable="columnPaymentType" msprop:Generator_ColumnPropNameInRow="PaymentType" msprop:Generator_ColumnPropNameInTable="PaymentTypeColumn" msprop:Generator_UserColumnName="PaymentType" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Receipt" msprop:Generator_TableClassName="ReceiptDataTable" msprop:Generator_TableVarName="tableReceipt" msprop:Generator_TablePropName="Receipt" msprop:Generator_RowDeletingName="ReceiptRowDeleting" msprop:Generator_RowChangingName="ReceiptRowChanging" msprop:Generator_RowEvHandlerName="ReceiptRowChangeEventHandler" msprop:Generator_RowDeletedName="ReceiptRowDeleted" msprop:Generator_UserTableName="Receipt" msprop:Generator_RowChangedName="ReceiptRowChanged" msprop:Generator_RowEvArgName="ReceiptRowChangeEvent" msprop:Generator_RowClassName="ReceiptRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ReceiptNo" msprop:Generator_ColumnVarNameInTable="columnReceiptNo" msprop:Generator_ColumnPropNameInRow="ReceiptNo" msprop:Generator_ColumnPropNameInTable="ReceiptNoColumn" msprop:Generator_UserColumnName="ReceiptNo" type="xs:int" />
              <xs:element name="ReceiptDate" msprop:Generator_ColumnVarNameInTable="columnReceiptDate" msprop:Generator_ColumnPropNameInRow="ReceiptDate" msprop:Generator_ColumnPropNameInTable="ReceiptDateColumn" msprop:Generator_UserColumnName="ReceiptDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ReceiptTableName" msprop:Generator_ColumnVarNameInTable="columnReceiptTableName" msprop:Generator_ColumnPropNameInRow="ReceiptTableName" msprop:Generator_ColumnPropNameInTable="ReceiptTableNameColumn" msprop:Generator_UserColumnName="ReceiptTableName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ReceiptServerName" msprop:Generator_ColumnVarNameInTable="columnReceiptServerName" msprop:Generator_ColumnPropNameInRow="ReceiptServerName" msprop:Generator_ColumnPropNameInTable="ReceiptServerNameColumn" msprop:Generator_UserColumnName="ReceiptServerName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ReceiptSubTotal" msprop:Generator_ColumnVarNameInTable="columnReceiptSubTotal" msprop:Generator_ColumnPropNameInRow="ReceiptSubTotal" msprop:Generator_ColumnPropNameInTable="ReceiptSubTotalColumn" msprop:Generator_UserColumnName="ReceiptSubTotal" type="xs:decimal" minOccurs="0" />
              <xs:element name="ReceiptTaxTotal" msprop:Generator_ColumnVarNameInTable="columnReceiptTaxTotal" msprop:Generator_ColumnPropNameInRow="ReceiptTaxTotal" msprop:Generator_ColumnPropNameInTable="ReceiptTaxTotalColumn" msprop:Generator_UserColumnName="ReceiptTaxTotal" type="xs:decimal" minOccurs="0" />
              <xs:element name="ReceiptAutoGrat" msprop:Generator_ColumnVarNameInTable="columnReceiptAutoGrat" msprop:Generator_ColumnPropNameInRow="ReceiptAutoGrat" msprop:Generator_ColumnPropNameInTable="ReceiptAutoGratColumn" msprop:Generator_UserColumnName="ReceiptAutoGrat" type="xs:decimal" minOccurs="0" />
              <xs:element name="ReceiptGrat" msprop:Generator_ColumnVarNameInTable="columnReceiptGrat" msprop:Generator_ColumnPropNameInRow="ReceiptGrat" msprop:Generator_ColumnPropNameInTable="ReceiptGratColumn" msprop:Generator_UserColumnName="ReceiptGrat" type="xs:decimal" minOccurs="0" />
              <xs:element name="ReceiptDiscountTotal" msprop:Generator_ColumnVarNameInTable="columnReceiptDiscountTotal" msprop:Generator_ColumnPropNameInRow="ReceiptDiscountTotal" msprop:Generator_ColumnPropNameInTable="ReceiptDiscountTotalColumn" msprop:Generator_UserColumnName="ReceiptDiscountTotal" type="xs:decimal" minOccurs="0" />
              <xs:element name="ReceiptGrandTotal" msprop:Generator_ColumnVarNameInTable="columnReceiptGrandTotal" msprop:Generator_ColumnPropNameInRow="ReceiptGrandTotal" msprop:Generator_ColumnPropNameInTable="ReceiptGrandTotalColumn" msprop:Generator_UserColumnName="ReceiptGrandTotal" type="xs:decimal" minOccurs="0" />
              <xs:element name="ReceiptPaymentType" msprop:Generator_ColumnVarNameInTable="columnReceiptPaymentType" msprop:Generator_ColumnPropNameInRow="ReceiptPaymentType" msprop:Generator_ColumnPropNameInTable="ReceiptPaymentTypeColumn" msprop:Generator_UserColumnName="ReceiptPaymentType" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ReceiptData" msprop:Generator_TableClassName="ReceiptDataDataTable" msprop:Generator_TableVarName="tableReceiptData" msprop:Generator_TablePropName="ReceiptData" msprop:Generator_RowDeletingName="ReceiptDataRowDeleting" msprop:Generator_RowChangingName="ReceiptDataRowChanging" msprop:Generator_RowEvHandlerName="ReceiptDataRowChangeEventHandler" msprop:Generator_RowDeletedName="ReceiptDataRowDeleted" msprop:Generator_UserTableName="ReceiptData" msprop:Generator_RowChangedName="ReceiptDataRowChanged" msprop:Generator_RowEvArgName="ReceiptDataRowChangeEvent" msprop:Generator_RowClassName="ReceiptDataRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ReceiptNo" msprop:Generator_ColumnVarNameInTable="columnReceiptNo" msprop:Generator_ColumnPropNameInRow="ReceiptNo" msprop:Generator_ColumnPropNameInTable="ReceiptNoColumn" msprop:Generator_UserColumnName="ReceiptNo" type="xs:int" />
              <xs:element name="ReceiptQTY" msprop:Generator_ColumnVarNameInTable="columnReceiptQTY" msprop:Generator_ColumnPropNameInRow="ReceiptQTY" msprop:Generator_ColumnPropNameInTable="ReceiptQTYColumn" msprop:Generator_UserColumnName="ReceiptQTY" type="xs:int" minOccurs="0" />
              <xs:element name="ReceiptDescription" msprop:Generator_ColumnVarNameInTable="columnReceiptDescription" msprop:Generator_ColumnPropNameInRow="ReceiptDescription" msprop:Generator_ColumnPropNameInTable="ReceiptDescriptionColumn" msprop:Generator_UserColumnName="ReceiptDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ReceiptItemTotal" msprop:Generator_ColumnVarNameInTable="columnReceiptItemTotal" msprop:Generator_ColumnPropNameInRow="ReceiptItemTotal" msprop:Generator_ColumnPropNameInTable="ReceiptItemTotalColumn" msprop:Generator_UserColumnName="ReceiptItemTotal" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:EmployeeInfo" />
      <xs:field xpath="mstns:EmployeeID" />
    </xs:unique>
    <xs:unique name="EmployeeLogin_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:EmployeeLogin" />
      <xs:field xpath="mstns:EmployeeID" />
    </xs:unique>
    <xs:unique name="EmployeeTimeSheet_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:EmployeeTimeSheet" />
      <xs:field xpath="mstns:EntryID" />
    </xs:unique>
    <xs:unique name="JobTitles_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:JobTitles" />
      <xs:field xpath="mstns:EntryID" />
    </xs:unique>
    <xs:unique name="ModificationList_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ModificationList" />
      <xs:field xpath="mstns:EntryID" />
    </xs:unique>
    <xs:unique name="PaymentTypes_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PaymentTypes" />
      <xs:field xpath="mstns:EntryID" />
    </xs:unique>
    <xs:unique name="Receipt_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Receipt" />
      <xs:field xpath="mstns:ReceiptNo" />
    </xs:unique>
  </xs:element>
</xs:schema>